﻿namespace Me.Amon.Da.Db.OMS
{
    public class DSpu : DVcs
    {
        public const string TABLE = "oms_spu";

        public const string ID = "id";
        /// <summary>
        /// 商品编号（系统）
        /// </summary>
        public const string CODE = "code";
        /// <summary>
        /// 商品名称（系统）
        /// </summary>
        public const string NAME = "name";
        /// <summary>
        /// 汉语拼音
        /// </summary>
        public const string HYPY = "hypy";
        /// <summary>
        /// 商品编号（商家）
        /// </summary>
        public const string MERCHANT_CODE = "merchant_code";
        /// <summary>
        /// 商品名称（商家）
        /// </summary>
        public const string MERCHANT_NAME = "merchant_name";
        /// <summary>
        /// 规格
        /// </summary>
        public const string SPEC = "spec";
        /// <summary>
        /// 型号
        /// </summary>
        public const string MODE = "mode";
        /// <summary>
        /// 计量单位
        /// </summary>
        public const string UOM_ID = "uom_id";
        /// <summary>
        /// 分类
        /// </summary>
        public const string CAT_ID = "cat_id";
        /// <summary>
        /// 品牌
        /// </summary>
        public const string BRAND_ID = "brand_id";
        /// <summary>
        /// 商家
        /// </summary>
        public const string MERCHANT_ID = "merchant_id";
        /// <summary>
        /// 组合商品
        /// </summary>
        public const string PID = "pid";
        /// <summary>
        /// 组合数量
        /// </summary>
        public const string PQTY = "pqty";
        /// <summary>
        /// 系列商品
        /// </summary>
        public const string SID = "sid";
        /// <summary>
        /// 系列数量
        /// </summary>
        public const string SQTY = "sqty";
        /// <summary>
        /// 规格数量
        /// </summary>
        public const string CQTY = "cqty";
        /// <summary>
        /// 库存上限
        /// </summary>
        public const string MAX_INV = "max_inv";
        /// <summary>
        /// 库存下限
        /// </summary>
        public const string MIN_INV = "min_inv";
        /// <summary>
        /// 保持期年
        /// </summary>
        public const string VALID_YEAR = "valid_year";
        /// <summary>
        /// 保质期月
        /// </summary>
        public const string VALID_MONTH = "valid_month";
        /// <summary>
        /// 保质期日
        /// </summary>
        public const string VALID_DAY = "valid_day";
        public const string USABLE_INV = "usable_inv";
        public const string REJECT_INV = "reject_inv";
        /// <summary>
        /// 是否会员商品
        /// </summary>
        public const string IS_VIP = "is_vip";
        /// <summary>
        /// 是否折上折商品
        /// </summary>
        public const string IS_PRO = "is_pro";
        /// <summary>
        /// 是否促销
        /// </summary>
        public const string HAS_POINT = "has_point";
        public const string STATUS = "status";
        public const string UPDATE_TIME = "update_time";
        public const string UPDATE_USER = "update_user";
        public const string CREATE_TIME = "create_time";
        public const string CREATE_USER = "create_user";
        /// <summary>
        /// 所属公司
        /// </summary>
        public const string CORP_ID = "corp_id";
    }
}